Code To HaveN
Home
Categories
Online Judge
Youtube Tutorial
Sabiul Sabit
Problem:
Group employees based on the first 3 digit of their phone number. Avoid employees from department no 10 or 20 or 60 and also avoid those groups where total salaries of employees is less than 50000.
Copy to clipboard
Copy
Published: Thu Jan 21 2021
Post Views: 220
MySQL
Select (4)
Operator(24)
Function (23)
Order(2)
Distinct (4)
Limit (3)
As(4)
Group By(14)
Having (3)
Join(19)
Add Your Comment
Your Name
Comment
Copyright © 2020 Code to HaveN
Add Your Comment